Tabela LReservationDescriptiveData

Definicja tabeli LReservationDescriptiveData

Name

LReservationDescriptiveData

Code

LReservationDescriptiveData

Comment

Tabela zawiera link pomiedzy wizyta (Reservation) a dana opisowa (DescriptiveData). Zostala dodana poniewaz dane opisowe zapisywane sa z E-portalu gdy utworzono juz rezerwacje ale nie istnieje jeszcze Event.


Lista kolumn tabeli LReservationDescriptiveData

Name

Code

DescriptiveDataID

DescriptiveDataID

ReservationID

ReservationID

Active

Active


Kolumna DescriptiveDataID tabeli LReservationDescriptiveData

Definicja kolumny DescriptiveDataID tabeli LReservationDescriptiveData

Name

DescriptiveDataID

Code

DescriptiveDataID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ReservationID tabeli LReservationDescriptiveData

Definicja kolumny ReservationID tabeli LReservationDescriptiveData

Name

ReservationID

Code

ReservationID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID rezerwacji


Kolumna Active tabeli LReservationDescriptiveData

Definicja kolumny Active tabeli LReservationDescriptiveData

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

Yes

Comment

 


Lista kluczy tabeli LReservationDescriptiveData

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli LReservationDescriptiveData

Definicja klucza Identifier_1 tabeli LReservationDescriptiveData

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment